package com.laborder.sysyy.dao;

import com.laborder.sysyy.entity.Labs;
import com.laborder.sysyy.entity.Student;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;
/**
 * @Function: 实验室DAO层
 * @author: 786107529@qq.com FJL
 * @date:2018/9/8 17:39
 */
@Repository
@Mapper
public interface LabsDaoMapper {
	 /**
	   * @function: 实验室分页查询
	   * @author: 759057893@qq.com lyz
	   * @date: 2019/1/12 22:06
	   */
	  List<Labs> findLabsWithPage(Map<String, Object> map);
	  /**
	   * @Function: 总数查询
	   * @author: 786107529@qq.com FJL
	   * @date:2018/9/8 17:40
	   */
	  int getLabsCount(Map<String, Object> map);
	  /**
	   * @Function: 添加实验室信息
	   * @author: 786107529@qq.com FJL
	   * @date:2018/9/8 17:40
	   */
	  int saveLabsInfo(Labs labs);
	  /**
	   * @Function: 删除实验室信息
	   * @author: 786107529@qq.com FJL
	   * @date:2018/9/8 17:40
	   */
	 int delLabsInfo(int lId);

	/**
	 * @function: 批量删除实验室信息
	 * @author: 759057893@qq.com lyz
	 * @date: 2019/1/11 17:07
	 */
	int delManyLabsInfo(int lId);
	 /**
	  * @Function: 查询实验室信息
	  * @author: 786107529@qq.com FJL
	  * @date:2018/9/8 17:40
	  */
	 Labs getLabsInfo(String lId);
	 /**
	  * @Function: 更新实验室信息
	  * @author: 786107529@qq.com FJL
	  * @date:2018/9/8 17:40
	  */
	 int updateLabsInfo(Labs labs);
	 /**
	  * @Function: 获得所有Lab
	  * @author: 786107529@qq.com FJL
	  * @date:2019/1/8 17:18
	  */
	 List<Labs> getAllLabs();

	  /**
	    * @function: 根据名称和地点来进行查询
	    * @author: 759057893@qq.com lyz
	    * @date: 2019/1/13 13:48
	    */
	  Labs getLabsInfoByName(@Param("lName") String lName,@Param("lRoom") String lRoom);

	/**
	 * @function: 根据Id查询实验室信息
	 * @author: 759057893@qq.com lyz
	 * @date: 2019/1/10 14:39
	 */

}
